<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="mm_lodging1.css" type="text/css" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body {
	background-color: #0099CC;
}
.style2 {font-family: Arial, Helvetica, sans-serif}
.style3 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #000000;
	font-weight: bold;
}
.style5 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; }
-->
  </style>

</head>
<body class="style5">
<h1 align="center" class="pageName style3"><span class="style2">View tour</span><img src="Imagenes/login2.png" width="32" height="28" /></h1>
<p>Select a Tour</p>
<form id="form1" name="form1" method="post" action="MapShowTours.php" target="mainFrame">
  <table width="335">
<?php
	include "Global.php";
	//Conexion a mysql y a la base de datos
	$connection = DBConnect();
	
	//Selecciona todos los lugares de la base de datos
	$query2="select * from tours"; 
	$resultado2 = mysql_query($query2) or die ('\n error en query ' . mysql_error());
	while($row = mysql_fetch_assoc($resultado2)){
		$id=$row['IDtour'];
		$name= $row["Name"];
		$description= $row["Description"];
		echo "<tr>";
		echo "<td><label>";
		echo "<input type='radio' name='tour' value='$id' id='$id'/>";
		echo "$name</label></td>";
		echo "<td>$description</td>";
		echo "</tr>";
	}	
	DBCLose($connection);	
	?>
  </table>
     
     <div align="center">
     <br />
       <input name="View" type="submit" value="View Tour" class="subHeader"/>
     </div>
</form>

<form id="form2" name="form2" method="post" action="Map.php" target="mainFrame">
  <div align="center">
    <p>&nbsp;    </p>
    <p>
      <input name="exit" type="submit" class="subHeader" id="exit" value="Exit" />
      </p>
  </div>
</form>
</body>

</html>
